<?php 
$this->E_D("DROP TABLE IF EXISTS `db_member`;");
$this->E_C("CREATE TABLE `db_member` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `mobile` varchar(20) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `truename` varchar(20) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `checked` tinyint(1) DEFAULT '0',
  `checked_time` int(11) DEFAULT '0',
  `register_time` int(11) DEFAULT NULL,
  `login_num` int(11) DEFAULT '0',
  `last_login_ip` varchar(255) DEFAULT NULL COMMENT '最后登陆IP',
  `last_login_time` int(11) DEFAULT '0',
  `token` varchar(50) DEFAULT NULL,
  `zhuyinghangye` int(11) DEFAULT NULL COMMENT '主营行业',
  `kehuxingzhi` int(11) DEFAULT NULL COMMENT '客户性质',
  `guhua` varchar(255) DEFAULT NULL COMMENT '固定电话',
  `lianxiren` varchar(255) DEFAULT NULL COMMENT '联系人',
  `lianxiren_mobile` varchar(255) DEFAULT NULL COMMENT '联系人手机',
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8");
$this->E_D("replace into `db_member` values('10','18988888888','8e56813e74d056615cb12952d70c59a6','mine233','11211212121212','1','1','0','1563785971','34','116.227.134.44','1566558272',NULL,'211','61','021-1234561','mine1','13712345678','370858683@qq.com');");
$this->E_D("replace into `db_member` values('12','15821183924','8e56813e74d056615cb12952d70c59a6','上海小马科技',NULL,'1','1','0','1565169526','0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_member` values('13','15821183911','8e56813e74d056615cb12952d70c59a6','ggg','fasdfdsafsadf','0','1','0','1565170454','0',NULL,'0',NULL,'0','0','','','','');");
$this->E_D("replace into `db_member` values('14','15821183922','8e56813e74d056615cb12952d70c59a6','张小明','张小明工作室','1','1','0','1565171142','9','116.227.134.44','1567476016',NULL,'0','0','','','','');");
$this->E_D("replace into `db_member` values('15','18501719544','8e56813e74d056615cb12952d70c59a6','王焰坤','页溪','1','1','0','1567476570','6','101.80.152.42','1568874302',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_member` values('16','15821183943','8e56813e74d056615cb12952d70c59a6','','北京小吉科技有限公司','1','1','0','1567476976','0',NULL,'0',NULL,'0','0','','','','');");
$this->E_D("replace into `db_member` values('17','15821183965','8e56813e74d056615cb12952d70c59a6','','北京小吉科技有限公司','1','1','0','1567477046','0',NULL,'0',NULL,'0','0','','','','');");
$this->E_D("replace into `db_member` values('18','15821183928','578181b62c947117c4ca3876fd0f9759','','北京123科技有限公司','1','1','0','1567477215','29','192.168.1.9','1597988856',NULL,'0','0','','','','');");
$this->E_D("replace into `db_member` values('19','13062787289','cfa81f718b70d171e4aa1fa57f1b254c','诗和远方','公司','1','1','0','1567495396','10','101.80.152.42','1568948396',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_member` values('20','15216861742','5b13b2dd84e0fb345a45938833ef7885','','埃迈诺冠商贸有限公司','1','1','0','1567667983','7','101.230.195.140','1568773629',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_member` values('21','18512144688','4da7682cfdd1d3c42dedaec9b5732ae8','NEX test','NEX test','1','1','0','1568015502','1','101.230.195.140','1568015502',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_member` values('50','17081430554','8e56813e74d056615cb12952d70c59a68e56813e74d056615c','王二',NULL,'1','1','0','1569306992','1','192.168.1.3','1569306992',NULL,NULL,NULL,NULL,NULL,NULL,NULL);");

 ?>